SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441640 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441640 [ RunTime:0.002818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582641,657285,475188,377575,1011934,155775,884155,549680,923763,541773,694178,797695,88163,618388,248764,185576,61395,1015649,572411,686235,864856,372095,14482,36091,364529,388542,782881,83559,526800,390982,846844,1012120,802401,653892,251984,350631,195865,279647,34658,476350,36318,547244,619847,822055,994601,936646,100419,742278,895503,123297,1010626,569018,479827,839577,964557,194631,780129,598272,16038,759841) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000733s ]