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` = 1044942 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044942 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504455,265912,1002223,691422,455444,980432,222444,607556,291501,824534,386257,83096,729417,898677,543621,651732,883824,540762,307576,73221,360828,235162,343362,402913,88930,730643,263691,620489,850367,85832,941884,650002,688327,252014,364930,47062,446606,417010,509673,366796,506644,881241,665194,504413,782410,156014,324289,625381,157795,296843,857880,280549,3632,841066,687135,594716,555440,289527,152210,431335) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044942 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044942 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]