SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40791 LIMIT 1 [ RunTime:0.001849s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40791 [ RunTime:0.002120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473859,548353,744242,512935,374682,149664,847509,993336,35044,356015,1038943,518368,583588,455149,302584,169083,740302,556880,523995,641661,148038,817936,941867,894381,312881,810791,776334,6215,1029241,251332,643579,752284,194519,299427,496078,816657,488360,192137,475456,1045050,170088,1000586,537761,462972,258057,507834,611801,329849,755595,487679,367189,747631,853357,928033,143610,166188,79271,1005139,965286,234110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]