SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557328 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557328 [ RunTime:0.002156s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (464486,1021436,801951,786568,874652,551568,985662,966008,916352,129301,114890,329074,1048548,403790,628072,1009510,29209,838715,835054,817148,507723,305899,817786,752072,547066,853847,169543,39874,65283,1030723,485508,927076,75373,179713,45889,477981,552243,329680,67883,105146,449749,450141,808953,610556,300794,149561,378140,664276,255481,201664,359375,162451,316542,304093,768018,800311,140739,51523,756712,122411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]