SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442043 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442043 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1235,211415,89866,550391,107484,676170,588178,256046,681411,744776,420250,16185,655732,674883,646423,383408,300579,356700,872860,779553,416799,57577,235924,390077,419593,889828,393086,1021310,428079,262160,799768,657655,857124,509889,101668,890210,27104,421252,488015,533300,305056,163261,668718,986618,794384,350154,577905,939122,359465,67310,660929,1043317,190851,1034697,1018936,872864,805385,995083,14427,519204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001718s ]