SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48272 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48272 [ RunTime:0.001994s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015739,153758,8679,392957,578094,1006896,235286,902410,66382,1008451,985958,639409,1031349,704950,1030637,137159,65468,273957,70118,552102,99828,122882,315740,59496,1025850,896786,534054,871564,662991,676498,58901,360756,430704,618077,379604,369674,4931,28501,364365,458228,320268,594925,900423,889745,752074,709331,723859,975983,580492,272140,32724,355574,112933,200013,328668,570208,615513,260574,553771,943027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48272 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48272 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]