SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002025s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260612 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260612 [ RunTime:0.004146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000195,822690,743272,964019,449317,218168,670262,290171,1023014,851781,94124,197656,6027,474073,73045,826776,486911,381161,756339,198482,474648,606634,811689,884910,47538,252965,227162,965763,822123,59519,424933,866903,58797,21218,872321,559386,506522,560492,552666,140787,459828,984739,486180,94432,297070,909015,671616,1007623,415720,400903,719053,703380,181878,706581,163047,653182,751971,172023,356415,480812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]