SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517004 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517004 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953494,5528,24288,506863,1037531,828695,942533,408863,643886,216219,958276,255253,825170,1039702,518507,166225,16023,350826,180070,1023540,687868,386043,656565,607258,414267,864200,158908,204769,343521,803267,786938,427097,339173,366682,640900,36637,271878,652638,347311,366931,668500,480688,175421,942562,293641,1005119,354065,754175,372846,1041249,972411,808908,725779,930948,705247,891045,396467,663548,323120,521543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]