SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 2614 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2614 [ RunTime:0.002575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471724,147723,208200,233296,424257,912018,168240,469158,619540,738638,466831,819396,721328,455237,36783,961344,859089,787201,1000744,1037664,26229,923946,1027976,307962,412749,235589,625391,860582,981322,456799,111590,179259,215814,570453,710937,386596,576220,579490,884314,46605,713117,958498,943766,44645,571913,1022204,829873,914739,35182,297525,513759,807858,186513,300843,646119,858674,475216,288841,320715,629432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]