SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598504 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598504 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (924019,561866,882795,1014622,281859,530694,416496,57209,201759,691395,268919,1016802,106998,582499,262176,534411,940580,1017433,310450,537442,759614,217230,277364,310143,159276,985409,1000299,558950,596877,522080,284531,789093,893051,964376,815417,796175,444221,593886,350311,345217,521244,720208,790476,839188,486040,883818,240626,905326,596959,104574,342445,129591,303827,484696,429777,590319,559894,448527,735296,425749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000804s ]