SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019749 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019749 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581717,199652,885719,393193,740494,669609,1024829,382206,35003,664785,109064,97873,731549,153334,434584,149922,1006527,195581,630894,299404,275269,990711,806766,494381,284154,167762,358461,1780,772259,54218,909080,216859,487074,400283,363045,404285,173809,519437,1502,99487,703690,423802,868530,201351,148204,290745,237687,417000,359015,472928,539048,823461,452897,614926,450971,417727,878937,741124,617514,301692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002237s ]