SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312241 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312241 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (624308,225457,179867,601498,812922,899952,356803,327013,168848,68819,367302,760078,659811,205493,286523,421181,419474,940998,55286,131772,681568,547229,544880,707951,60327,313207,608644,296372,164504,236260,855814,730767,956107,48315,357089,884802,905341,496046,846473,203975,431524,1019854,803107,199121,330645,425236,660474,878153,487239,964471,949771,878086,79168,30972,834776,366062,748762,667974,827857,967764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]