SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 337244 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 337244 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (168578,879995,531617,410707,199635,750491,68266,824319,102546,936514,611621,639694,115570,443158,642118,595279,404318,39454,830787,497875,418109,456995,692731,433290,196051,812707,170504,1004318,398807,670799,715939,913241,99005,882426,141869,596784,48501,108090,937389,254259,758882,322303,409946,962788,1045357,1044785,268380,209053,174305,300452,707500,528716,448302,926721,158060,939615,746542,412602,5266,499671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 337244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000636s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 337244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003610s ]