SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591790 LIMIT 1 [ RunTime:0.002972s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591790 [ RunTime:0.006619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (749742,540102,341112,102645,902409,695513,161970,84217,177911,763669,828626,711561,527450,200888,250245,750790,233660,441072,366999,150376,782517,186872,1030374,144961,643002,611422,854766,117457,167148,924013,548976,122782,456065,397660,1013887,356877,189145,747900,317187,548645,358215,146023,583365,921162,774457,770035,386815,545000,339474,546003,1003913,738382,813023,547157,1037183,287053,653308,247172,320844,325295) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004778s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]