SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672741 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672741 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444098,334478,534695,658575,75860,1044853,796589,334396,656880,660988,689513,43855,485985,395330,777943,511942,606315,619520,651671,588086,802292,45755,1009010,49574,792830,554032,805879,981097,220235,942410,1044016,584770,679655,507860,81032,931439,58800,180694,243350,1008660,429176,226014,262667,177916,210175,98863,247366,953320,757252,961719,869811,888310,317628,992987,341461,620892,88255,253159,76786,634847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]