SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589089 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589089 [ RunTime:0.003456s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671690,53702,834395,604014,763407,97050,641298,570683,1035639,887751,980351,366580,147788,703631,525537,525917,524782,314490,766960,175648,463135,612357,742619,701851,389736,1044666,140361,800897,699509,367413,759323,754484,60869,797209,252286,504326,474264,299455,684837,124103,326328,776316,95985,473487,889845,711648,167202,235667,182093,692883,510870,969884,466838,997182,885311,856655,706839,722876,162073,587328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]