SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100988 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100988 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818545,489397,654943,778488,751799,861103,516465,584185,764380,147997,482434,545020,486903,542721,1001460,482471,264638,614606,490264,873023,745955,717090,269395,770386,399283,44452,75104,658696,935973,733581,24064,139936,849208,66175,852741,651741,1020788,896497,735605,933824,184910,906587,277527,810856,716607,304104,148541,123976,183406,912807,240557,811940,738099,18197,983225,465007,1044233,625424,1032160,663344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]