SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381970 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381970 [ RunTime:0.003246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666950,246608,122704,263383,741168,675558,717032,466820,285671,88617,888996,651119,1017658,986210,453285,52584,976146,546178,904940,127289,523171,626639,1007934,616036,66711,7405,110672,387962,73932,626032,962907,853972,983314,431581,156838,904098,963400,873389,984766,839335,338668,477408,1048000,801482,755967,80980,286512,769046,644517,485805,717207,183425,292366,170935,1025260,432952,523441,771489,410908,613690) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381970 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381970 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002679s ]