SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468994 LIMIT 1 [ RunTime:0.001418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468994 [ RunTime:0.001793s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503814,381890,805679,907664,319411,163298,181480,123827,417903,510313,646879,871377,621076,268766,786067,663047,907424,164810,554705,196494,905830,303617,1030212,845704,219692,884378,599097,451470,483975,484363,235633,586537,259895,458575,603394,653083,861561,935532,131322,834804,43307,239686,165283,440810,705727,319420,614125,39470,541170,470366,269050,238378,744532,517171,571943,367400,883090,1028429,575072,240006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]