SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020944 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020944 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203204,672740,38208,507468,726058,122487,324954,262922,574106,180461,876823,155967,922673,877755,753626,38873,928073,863077,631936,131846,107719,492555,237969,638428,1007449,986539,940269,1022392,34016,924678,550511,1018883,489862,858346,250754,103548,181749,561734,486765,840077,561293,193348,318163,103761,766561,1034640,76570,282073,688560,827243,847354,928379,885357,463098,656422,502354,888581,13062,318777,313182) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020944 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020944 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]