SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201294 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201294 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910804,473761,271033,570835,884913,636408,209911,675233,889852,391642,716320,321253,471726,77012,794343,848673,185411,252666,617814,462676,1040774,417967,182714,205649,208265,425963,729045,221062,33959,10831,26303,964192,239184,39571,96141,45386,915536,438406,193614,496886,202882,512837,283973,935376,452081,952754,865119,136671,604233,15844,1000556,197575,820476,170071,54497,49334,121022,930780,516120,888908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]