SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291599 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291599 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (140760,949630,656185,878371,114823,341842,117966,1032303,659984,9997,745325,976359,138057,7579,124564,586715,531316,79490,629899,965373,214767,541639,944353,605757,454686,354116,790266,808233,446778,61244,1013125,484102,87708,701427,1031554,801660,431586,842477,163141,289829,301786,321229,1048867,463776,334651,64878,977733,879249,531005,71424,142456,505654,96033,1001734,239774,803461,526957,969934,1838,645044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]