SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38402 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38402 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333308,15267,198620,255711,130165,1046440,147942,985052,729470,665787,3512,566845,818540,161605,954442,761035,47621,36300,778532,1005488,892260,60475,682827,775090,62189,108461,79084,926917,524351,603047,612735,219459,451,282536,216368,605210,954972,975980,97503,1010171,899316,207955,831842,256105,127428,465214,859269,524257,555225,669338,71125,655788,858694,1048132,1028578,56125,679566,843167,457094,248829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000978s ]