SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041244 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041244 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468415,641555,960288,710740,611024,180332,840181,458807,601434,133862,216822,106376,938944,179306,9839,489620,117697,358300,491728,113592,229596,313560,708243,125513,763061,424761,291309,755129,549238,117704,161941,778206,184835,76324,688560,1029918,477130,990162,204329,638206,675964,940380,345522,267581,66360,55001,883342,189058,433340,628240,27671,411694,1009353,469241,816621,1021747,926118,46315,1019034,804842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]