SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012017 LIMIT 1 [ RunTime:0.002336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012017 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207943,524244,890454,748238,631023,120650,524948,440891,1047648,67401,582570,616233,604523,108514,277439,171872,788398,648853,601448,602385,477846,566710,857928,219749,195594,698200,147934,230676,268762,50149,499728,486658,294532,506174,206636,186120,499622,508875,756082,538928,868376,159827,395034,904122,438856,99133,883555,274676,964937,287809,544946,891368,981904,785969,488408,704799,21918,552137,413996,453253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]