SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538802 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538802 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587910,82596,133590,601707,817349,100257,317137,32536,216209,216734,81299,410480,170021,610578,780455,738278,537158,234234,402786,407288,974770,797353,360987,847362,430236,720401,365771,39357,290646,693186,1027005,931547,688538,702690,765465,970846,379633,707688,360325,795281,747192,577280,1014329,888996,103258,106461,303011,685551,310967,542081,127240,934293,854067,706387,1033044,88584,890593,161653,661725,290491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538802 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538802 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]