SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015475 LIMIT 1 [ RunTime:0.002039s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015475 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551719,98397,213657,940619,788110,545580,432681,972058,712424,606227,16752,18910,615873,282414,723856,429343,555678,37787,133713,382059,456991,419070,349796,201202,298526,673296,1006566,819812,665910,848934,571139,392840,71097,605291,739212,1035819,110049,21344,439372,709122,336782,694943,221309,960920,823804,516782,624911,209873,532609,483518,707330,1042346,291214,220787,954871,44746,201028,824265,341782,236903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000381s ]