SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 377634 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 377634 [ RunTime:0.002240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (516823,850740,107962,533273,263928,425294,485160,998173,568061,677607,249757,1027968,155033,279020,380691,968112,1039614,735519,781379,245397,216682,430335,381818,771389,611294,398237,276509,581891,690332,530827,140002,341127,881611,344427,783999,118699,397515,909823,272036,762655,46907,904184,253962,657188,263572,938950,394549,154392,822218,410755,47996,962948,627368,708705,531239,198663,927993,882275,905506,397566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003875s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 377634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 377634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]