SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541158 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541158 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868058,661485,628909,634370,218052,483855,548146,1005266,585506,1003798,999126,117935,26087,738481,779471,204934,419617,260666,923156,952479,866707,626293,783317,231982,509173,689928,830113,1023505,767300,879003,988112,636190,647088,80836,223785,651772,117098,438139,782302,383933,79131,208438,366479,289158,1020746,828801,87841,315831,136294,63890,948608,986107,668974,846106,509291,569368,644970,958550,911368,616199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]