SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398839 LIMIT 1 [ RunTime:0.000637s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398839 [ RunTime:0.001784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (462747,869834,24412,942653,132171,138687,440485,471885,237801,235268,182712,383378,636614,510894,665437,474029,154079,693558,114057,1013923,684859,837248,401346,96583,827954,925999,530905,1005,201775,817307,371468,883229,763966,476153,861306,201301,42465,50354,317887,877691,579505,977811,424939,901867,431926,916083,385671,18296,130143,386181,28303,780681,209403,9791,785774,39948,129574,329082,996745,714881) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398839 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398839 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]