SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 147410 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 147410 [ RunTime:0.002301s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (320946,361621,826226,910889,157469,1031559,1019361,62864,580708,488075,251212,220220,1013569,90547,182867,744619,595424,268633,31985,800760,187245,924912,909805,82618,364713,69007,375904,133308,891073,372868,35222,75153,75476,109547,506119,969108,32000,554113,955708,573544,963391,1014732,402359,612924,165708,717682,530764,386234,630600,798788,687916,571098,402836,565091,434871,431005,285759,232353,822090,510646) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 147410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 147410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]