SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310983 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310983 [ RunTime:0.001554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286206,779257,630870,4817,259484,279012,526596,939291,963724,448366,229538,110039,395101,924340,586058,734462,574224,859716,215220,681369,964726,275197,181426,580248,667048,981448,662106,503392,675222,654404,861566,249764,602972,788275,707837,113200,589259,933519,378155,106442,1001046,251213,889236,264699,327626,1032656,906191,925542,33129,962707,160338,809732,1036895,760052,650578,887795,222898,295094,823633,592047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001661s ]