SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294500 LIMIT 1 [ RunTime:0.002905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294500 [ RunTime:0.002929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183566,234470,253422,680753,516042,237361,210791,359477,734153,653949,667128,312186,127574,1037711,63434,796644,975070,918024,39211,137866,720785,102224,194903,1001933,390850,503018,99541,751834,523904,207668,1011195,117426,651192,46814,460563,157383,1002214,475984,761836,941668,785765,372638,926589,275566,957729,238993,1019034,818695,835765,436434,535581,918578,630154,255394,12338,145023,1030329,191282,82145,226115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001795s ]