SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404019 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404019 [ RunTime:0.001659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260797,340246,3170,555180,310945,645141,385838,726535,720358,434180,814438,394344,722016,408963,439477,1016640,997298,699330,471436,1017212,669103,612636,730069,828352,233047,994713,623046,754102,932357,47861,71489,812572,907770,499109,498068,195495,548932,904161,409572,29344,453815,1022552,881717,33523,417157,797764,661381,558504,832679,88640,1034823,626607,560379,566539,618310,420577,145147,817885,959994,511182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]