SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 960081 LIMIT 1 [ RunTime:0.001455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 960081 [ RunTime:0.005748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927783,1048676,808962,7015,794628,257210,224911,657897,893518,156725,439656,761593,518609,899524,554192,987156,1030356,841320,896064,179538,251891,841566,898350,39930,248406,85501,143980,1040576,146992,374117,741091,667089,1043379,424077,423550,115518,515569,609793,286648,285984,17068,816481,237309,909373,772765,174444,811852,32021,148004,646908,908787,711345,95143,106233,335834,341822,790778,465467,548171,336626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 960081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 960081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]