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` = 496281 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496281 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (975755,773829,424290,94905,341043,1030998,61119,5313,873472,575293,306182,674744,747207,1002678,676131,656190,220759,214164,1045683,113005,258003,1035593,805062,424632,973989,408660,378156,623769,1047599,461205,971517,481236,592860,1027636,104334,658525,932343,950969,816058,297488,882875,704377,174491,902024,722950,722634,371378,535731,772060,693989,675993,707500,645991,741201,96778,612207,304236,883665,641609,1004850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000721s ]