SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455537 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455537 [ RunTime:0.003930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280581,1038780,22194,198802,459572,811169,861679,215499,217111,213146,555468,203530,852901,932812,1015676,504080,653266,439609,936824,344569,123280,1005277,102361,712962,60012,42096,497413,791503,58720,795672,912117,853877,736382,263127,159470,977665,99115,895756,308945,190542,545315,680462,679178,276648,931048,402035,41025,180092,61965,175791,808928,572146,630721,598140,653625,982998,813070,633740,856147,105076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455537 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455537 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]