SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 768043 LIMIT 1 [ RunTime:0.000533s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 768043 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (318430,765559,1037034,686207,762808,579614,182074,54802,586859,840049,749030,539221,581208,374306,430593,561990,897788,128135,278981,425575,575407,689126,188862,334833,569103,845113,936973,282022,85768,952177,168670,217594,1027139,819120,921490,997134,492880,607276,992638,206486,733718,219731,309543,436502,16530,432875,540580,428148,214987,45811,45319,783509,168239,58434,881138,597257,851616,750149,842092,866795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 768043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 768043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]