SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409296 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409296 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81853,750895,462024,285838,714452,792777,620591,448348,823454,904025,846691,765570,543632,810770,319395,542488,731440,784487,538655,398520,570892,832321,595502,968470,885796,844724,276504,877599,132584,1001273,226674,901133,1308,551497,927618,471910,353638,410438,263447,108329,346201,157373,926367,222800,749141,196540,589462,904348,882834,580743,533411,314451,339300,713056,481511,352131,840730,203496,615650,879608) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000743s ]