SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001440s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540220 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540220 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282341,579837,766408,362530,64331,896227,388587,830853,863550,476229,668982,491501,406771,384713,710713,78097,1032192,403542,773256,719898,1004532,1000853,323780,663947,896328,191687,715925,653352,661938,809853,546007,720718,985066,573254,1013034,367370,901270,1005217,615779,402336,194740,1002755,783689,715513,155846,349300,958389,343008,204533,699077,754634,1015085,683259,513807,662291,620335,6031,258330,1037776,61689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]