SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 72001 LIMIT 1 [ RunTime:0.002163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 72001 [ RunTime:0.002143s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (564526,1010379,197577,931340,631183,347001,605759,356069,349122,29322,986137,29701,245926,1007974,337204,546362,415135,417885,735285,56690,846826,980977,1027556,12279,266290,682294,211636,24467,167043,765599,380896,684714,39936,783752,99019,351918,916477,729784,781004,877165,992228,674013,230472,345326,5646,63815,867695,310181,208471,878802,333618,284476,676302,316350,236795,683273,515736,219994,885302,969819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 72001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 72001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]