SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557816 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557816 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191649,23834,243682,271060,314714,748957,891460,450933,140562,251104,447418,300957,198250,516738,571126,522465,30474,995658,595079,450106,461240,859231,887893,1021968,198792,5896,161687,119745,251922,177661,669812,859935,22800,472174,691868,635282,302201,81523,759482,577544,67653,811399,905217,701535,144868,44647,31569,278452,353087,1028031,944587,342870,83293,803768,50465,743249,626584,240801,42233,852774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]