SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501255 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501255 [ RunTime:0.004420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68158,332477,937239,1035300,386166,566941,817078,338298,375237,740840,347498,509758,478469,136730,521631,209378,687272,33175,543431,715442,287264,451638,771030,375945,592730,506674,191239,304397,636655,282530,235843,576494,669887,217489,415258,42803,938428,975583,82633,808682,54454,853567,789067,441682,956262,850264,673826,219672,1024865,809377,127413,535557,9718,65138,836281,61595,164453,423856,32074,718514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501255 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501255 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]