SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504556 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504556 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446799,313581,101670,690612,238500,807297,732670,923061,684617,457736,877595,587790,948189,352640,836561,947055,747496,274612,977777,972649,412700,218715,568680,250027,1031344,39498,84316,997916,976803,1009464,573268,6799,209537,1034536,878706,486573,732829,569464,688135,378493,978465,570110,807595,13724,725809,445804,942699,1001012,768217,454224,241507,180422,2453,567441,452618,781362,633334,690892,524754,836647) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504556 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000619s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504556 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]