SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018914 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018914 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477725,828999,22140,835055,1026326,1044612,244688,212486,727485,949226,460040,832475,806838,80504,366587,228166,854129,29765,712283,203463,1006210,760937,966033,123609,263374,865989,105422,805831,429512,590921,888516,929975,682159,73702,1008716,37829,210796,858831,553910,969709,675738,553352,473310,337808,483626,760213,994569,269528,667056,921878,110422,9774,917120,86050,376755,972119,11792,794379,827298,363481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]