SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014049 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014049 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457411,713774,532336,24845,838162,269212,177764,584755,698732,181937,491588,776443,156368,236672,660896,785934,337093,603709,507056,980789,890647,743548,691925,28299,712766,889276,660284,656536,816237,927429,686087,142223,992947,381331,575632,872960,705300,1012667,242964,282421,343698,589588,871245,286776,327899,211749,825212,758143,896935,2521,1020654,914299,740485,924103,956091,941822,1040657,184157,778465,749445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014049 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014049 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]