SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012026 LIMIT 1 [ RunTime:0.000443s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012026 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917184,595259,148446,322282,6661,380480,514397,726995,528585,75061,906638,675434,239825,160543,932945,701884,820391,413414,312230,815649,273534,808358,546052,321478,707338,425242,774103,152727,604998,108014,969620,839526,839237,151294,839418,781662,209701,8844,120237,975707,510777,142387,99219,811861,960784,821348,408183,169536,726828,656709,815032,854827,182263,669626,768564,802605,872828,516131,906323,552543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]