SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502234 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502234 [ RunTime:0.002266s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142647,763829,542041,143969,231217,387033,823128,557825,85127,626544,299453,601065,510073,633368,302187,752883,10723,742051,630236,641858,114136,475985,158307,472477,689506,204821,984470,182979,579992,978636,378616,940254,954146,790337,137447,909526,370775,24805,657467,677933,90337,989331,773327,686353,821599,736428,649197,963483,197871,1026680,818733,40512,504848,786164,493914,641496,115046,104304,98591,680865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502234 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502234 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]