SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492281 LIMIT 1 [ RunTime:0.001169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492281 [ RunTime:0.002107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186169,561230,416608,318460,692150,679700,468474,889545,515395,900313,11760,683839,966757,300330,1000185,305516,782603,39275,271060,145674,120320,44429,502078,857081,756891,575057,37581,278748,588830,671489,494492,443061,300905,502849,956463,1013287,841515,56056,184164,817887,836030,918625,753135,360001,817219,148370,489846,901290,392320,780055,852428,976943,604596,390668,579429,340827,266203,513808,625996,139120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]