SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527950 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527950 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463807,389337,112068,198658,924093,733885,496169,384295,537594,421228,940531,476450,450626,20973,47413,73331,16322,855140,696074,426678,344033,651742,807552,81305,954920,379339,827999,580482,41445,1006137,859993,708579,169225,978773,35140,795087,229313,188624,583228,573446,992233,808500,282594,689751,916719,1033108,367622,528081,980743,802876,331382,1030497,548673,714992,35898,822080,862138,473907,994244,815395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]