SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 905104 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 905104 [ RunTime:0.002998s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504515,505518,926033,281540,897465,548166,545601,389569,546849,912046,826544,323445,377420,365434,565825,55580,553341,912850,823902,42757,113007,71510,203474,369516,762374,848958,898465,171614,664030,837795,290840,903504,545914,36496,526271,769675,711711,752697,257928,108604,1037310,612184,640601,524390,14441,340480,239470,13497,49675,805559,720280,797035,140432,476531,121299,57684,1010952,427932,880086,1019178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 905104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 905104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]