SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004055s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116813 LIMIT 1 [ RunTime:0.001459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116813 [ RunTime:0.006171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908072,840518,365936,1028823,998670,812050,966445,836727,666769,964242,384174,99571,725241,464674,375658,304933,402399,588193,766110,411117,226792,631741,56880,537650,665825,286396,354513,420477,310856,960493,1037790,991592,271350,422804,222831,896732,667091,193881,634599,508124,317671,40178,179915,18573,994964,531782,284202,472059,381924,669255,6285,1048401,493335,681725,812916,120482,17560,249970,731326,775143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003226s ]