SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801151 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801151 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551838,633618,545536,536374,580832,735859,131113,765904,857031,1036667,528407,627979,645874,583473,111877,857352,885817,646981,419027,548643,2147,1002372,756358,149515,121370,424577,386364,520801,547986,107517,389371,495000,272252,547076,352776,894749,586644,74353,767895,369824,123794,72324,957825,150302,792676,460021,271592,783828,214909,119339,366546,957007,71219,536275,942987,298215,733712,508992,945082,447903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]