SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512364 LIMIT 1 [ RunTime:0.001215s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512364 [ RunTime:0.002204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424501,261459,647376,922628,659930,902589,316082,593206,473951,240988,1034200,203478,887047,1012526,865194,628401,14657,949285,44666,450222,591169,511983,129032,609217,172969,1022018,58874,472199,613824,4607,905786,632812,1040479,215234,611705,354818,243075,293123,453867,993745,796433,9800,378128,891993,488191,535081,916968,826037,690258,308367,328281,587505,1042475,138797,547349,207713,429039,191820,650722,344811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]