SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411220 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411220 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011860,1047024,656756,138791,570571,646233,157156,195162,798946,201206,670286,1037989,388465,530312,862785,758641,543505,18163,556744,706982,56278,815744,956321,82539,315930,761967,568675,709226,848482,753924,1005985,662833,480209,347098,586717,208825,406788,157705,373313,1002592,526500,861288,778302,944817,19888,953398,474500,335503,505824,169323,246932,147555,922534,331048,196061,373569,973723,1004427,243861,784707) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]