SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001533s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804308 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804308 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312762,491510,345686,510666,490801,235699,50848,294502,627927,849613,432321,1011252,953402,504568,233992,1040497,624506,795049,34546,303601,548055,767084,452917,391681,734851,11730,811454,653182,865515,940244,49424,365657,347191,448892,950254,793386,867906,232093,53095,59225,36348,649010,774716,367598,378381,1004895,954618,538156,366660,971784,44081,990483,417674,224505,282787,842264,277740,770497,588321,683340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]