SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516840 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516840 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269124,138329,955756,93155,169351,316908,710303,436184,776190,138580,279646,18806,407225,844553,1013585,681741,982255,274758,78276,529352,476238,65344,180043,810091,335248,40894,143896,166830,863162,225852,976357,358970,249239,154746,763006,210677,362519,745241,944700,547383,441676,185219,908449,1006395,153753,850971,792136,631673,1005135,220576,834969,317876,220704,391323,300035,243719,28149,943846,684462,582338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]