SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541059 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541059 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (73847,570488,479158,656491,502692,742117,767324,542601,289434,717819,803769,606097,827700,26031,689057,28935,1003765,463743,939949,872355,961117,341936,372588,233479,1037961,774627,735133,171004,898300,1041356,595883,159196,844627,990320,572994,95032,164437,741405,973976,1031396,891241,480706,78959,346762,375929,762331,567974,678502,397407,196684,1017555,880779,1013155,666341,700517,654570,340578,768070,299596,449210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541059 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001627s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541059 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]