SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50608 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50608 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407160,847962,726563,824309,6982,510862,740041,594689,1027072,510685,256786,473044,330359,988449,720880,375559,81728,117344,730525,1018243,719217,893110,194771,245510,765099,827106,255117,807089,38679,263618,218635,20358,244256,904788,937782,420318,942890,111968,457306,715593,438997,405866,1000466,76199,448292,281378,329978,439840,722208,62111,967648,174777,958259,646223,728660,108109,571539,296962,387152,299344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50608 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50608 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]