SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045771 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045771 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897122,869065,169443,146443,187014,41061,951536,615888,161808,996716,406752,875286,520063,57498,71264,533139,555970,1043686,578419,743514,535693,917744,886778,207574,856895,782286,1025778,140303,957730,849963,619345,1016808,1008294,790339,568869,278616,248019,628422,530701,613592,721757,186394,853573,1013617,976993,500774,526713,61973,706811,206699,1048502,548237,384900,541832,360667,661383,254355,550084,259911,428685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]