SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299790 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299790 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724024,123425,581348,592513,744915,412294,306819,932270,798081,817386,252413,391287,593119,641108,872016,318459,410919,115277,825750,156938,1022265,219642,751805,613978,710396,325162,902037,230272,71879,335990,893073,270838,1018751,758803,693781,319350,692037,41283,494159,788534,500892,856788,710787,601684,362347,338592,791256,777236,1011595,95624,326139,541314,591017,507158,636410,34274,189776,165764,989497,738091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]