SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501394 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501394 [ RunTime:0.002160s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (955322,330873,327584,813212,505592,56218,406238,677858,884913,389695,460354,798552,641266,616257,208261,684290,523917,387890,506039,602786,948102,424205,75171,39706,523366,260052,199565,144249,851549,259665,879173,22349,750438,171383,430875,46089,106111,889847,228024,804975,342579,88580,734468,546325,1048395,107263,247268,103160,306659,571191,324804,909367,263833,826265,445100,354583,662540,471114,799677,184518) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]