SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.008907s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496439 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496439 [ RunTime:0.002580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351886,645051,154754,663070,445320,72310,135309,10504,514824,425459,1006083,1027505,814305,19527,80791,810630,205541,352671,532903,489234,1004560,810034,478656,123465,898396,447862,763968,574202,714831,644429,244185,407304,871766,107238,874336,817511,348575,346129,334410,983846,187699,301823,796211,23038,923671,1007666,587767,939358,67840,936260,682532,726997,359238,692097,12282,81583,126364,122207,42525,288351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]