SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507813 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507813 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391826,106830,416004,314583,391248,724307,825921,438575,827289,1006504,74707,724837,508068,775691,934455,703857,749371,464582,908416,975022,36902,788813,766329,150306,57909,285905,469089,622949,59769,271453,776560,6938,729330,312133,840731,781192,775236,528121,1013631,209164,855329,732680,660311,442110,701131,678259,418470,449971,840810,686287,984656,652601,391836,72727,612169,633292,227895,290896,523752,196912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]