SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211887 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211887 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473176,121741,175871,178437,786791,233030,645730,692199,561918,107281,549161,965660,134377,715000,463097,475831,768081,660071,402439,14875,1024161,956007,366918,882159,314901,287653,114964,81697,288424,721600,221028,331432,125301,156802,579069,933464,623817,728680,1010500,928317,628825,511746,780608,119085,357343,544230,435633,112090,776684,504927,177195,983520,773845,845554,486360,756686,680931,460906,585492,202830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211887 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211887 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]